Use [HMS]
Go
ALTER TABLE dbo.Doctor_Slot
ADD Doc_Day_Off date

update dbo.Doctor_Slot set Doc_Day_Off = (select convert(date, getdate()))
